home *** CD-ROM | disk | FTP | other *** search
/ mail.altrad.com / 2015.02.mail.altrad.com.tar / mail.altrad.com / TEST / office deutch / ACCESS.NL-NL / ACCLR.CAB / ACCESS_TEMPLATE_SALESPIPELINE.ACCDT_1043 / template / database / objects / tableOpportunities.xsd < prev   
Extensible Markup Language  |  2006-11-12  |  29KB  |  490 lines

  1. ∩╗┐<?xml version="1.0" encoding="utf-8"?>
  2. <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:od="urn:schemas-microsoft-com:officedata">
  3.     <xsd:element name="dataroot">
  4.         <xsd:complexType>
  5.             <xsd:sequence>
  6.                 <xsd:element ref="Opportunities" minOccurs="0" maxOccurs="unbounded"/>
  7.             </xsd:sequence>
  8.             <xsd:attribute name="generated" type="xsd:dateTime"/>
  9.         </xsd:complexType>
  10.     </xsd:element>
  11.     <xsd:element name="Opportunities" od:rename="Kansen">
  12.         <xsd:annotation>
  13.             <xsd:appinfo>
  14.                 <od:index index-name="ContactID" index-key="Customer " primary="no" unique="no" clustered="no" order="asc"/>
  15.                 <od:index index-name="CustomerOpportunity" index-key="Customer " primary="no" unique="no" clustered="no" order="asc"/>
  16.                 <od:index index-name="EmpoyeeOpportunity" index-key="Employee " primary="no" unique="no" clustered="no" order="asc"/>
  17.                 <od:index index-name="OpportunityID" index-key="ID " primary="no" unique="no" clustered="no" order="asc"/>
  18.                 <od:index index-name="PrimaryKey" index-key="ID " primary="yes" unique="yes" clustered="no" order="asc"/>
  19.                 <od:tableProperty name="AppendOnly" type="1" value="1"/>
  20.                 <od:tableProperty name="Orientation" type="2" value="0"/>
  21.                 <od:tableProperty name="TotalsRow" type="1" value="0"/>
  22.                 <od:tableProperty name="FilterOnLoad" type="1" value="0"/>
  23.                 <od:tableProperty name="OrderByOnLoad" type="1" value="1"/>
  24.                 <od:tableProperty name="OrderByOn" type="1" value="0"/>
  25.                 <od:tableProperty name="DefaultView" type="2" value="2"/>
  26.                 <od:tableProperty name="WSSTemplateID" type="3" value="120"/>
  27.                 <od:tableProperty name="DisplayViewsOnSharePointSite" type="2" value="1"/>
  28.                 <od:tableProperty name="StarColumnHidden" type="1" value="0"/>
  29.                 <od:tableProperty name="NameMap" type="11" value="CswOVQAAAAD5OD9N5LabSpw/R1amTV3vAAAAAHLJSslXCuNAQAAAAAEAAABPAHAA
  30. cABvAHIAdAB1AG4AaQB0AGkAZQBzAAAAAAAAAGPdDZbi7R5Jipz5IF2ZGl4HAAAA
  31. +Tg/TeS2m0qcP0dWpk1d70kARAAAAAAAAACLuZIMlI1zS6AIbSmO8MqUBwAAAPk4
  32. P03ktptKnD9HVqZNXe9UAGkAdABsAGUAAAAAAAAAcjPebVkZwkOLh1UNin6t/QAA
  33. AADs4HTKVwrjQEUAbQBwAGwAQwB1AHMAdABvAG0AZQByAHMAIABFAHgAdABlAG4A
  34. ZABlAGQAAAAAAAAASykVLAEWSESiNaqe+zBt9wcAAAByM95tWRnCQ4uHVQ2Kfq39
  35. SQBEAAAAAAAAAGXnqXNpvMBPv5eJeZ/BDCIHAAAAcjPebVkZwkOLh1UNin6t/UMA
  36. bwBuAHQAYQBjAHQAIABOAGEAbQBlAAAAAAAAAGmPtHLskkFJpqClj70ZlHMHAAAA
  37. cjPebVkZwkOLh1UNin6t/UMAbwBtAHAAYQBuAHkAAAAAAAAA4hErgye8NkS7Iv12
  38. h+gUwwcAAAD5OD9N5LabSpw/R1amTV3vQwB1AHMAdABvAG0AZQByAAAAAAAAAKxS
  39. GFBMiP9NhJN7itQZ4poBAAAAug3M7lcK40AAAAAAAAAAAEMAdQBzAHQAbwBtAGUA
  40. cgAgAEQAZQB0AGEAaQBsAHMAAAAAAAAAwB73uqPecEavMy+UytWTOAAAAAC6nIjK
  41. VwrjQAEAAABAKSg0RQBtAHAAbABvAHkAZQBlAHMAIABFAHgAdABlAG4AZABlAGQA
  42. AAAAAAAAWQhPEHQHZ029KTWsWk+59wcAAADAHve6o95wRq8zL5TK1ZM4SQBEAAAA
  43. AAAAAIsiFQxbqclGjoZIf1orf14HAAAAwB73uqPecEavMy+UytWTOEUAbQBwAGwA
  44. bwB5AGUAZQAgAE4AYQBtAGUAAAAAAAAAXAMbTmCZfEakYvFBLu+CEwcAAAD5OD9N
  45. 5LabSpw/R1amTV3vRQBtAHAAbABvAHkAZQBlAAAAAAAAALe/fm5qtTBHpoG1TZdI
  46. 77cBAAAA1qbs7lcK40AAAAAAAAAAAEUAbQBwAGwAbwB5AGUAZQAgAEQAZQB0AGEA
  47. aQBsAHMAAAAAAAAAqU1Q2JSvVEO+Mf/sGyWueAcAAAD5OD9N5LabSpw/R1amTV3v
  48. QwBhAHQAZQBnAG8AcgB5AAAAAAAAAORwnb27ex9JjLKGlCAW8/4HAAAA+Tg/TeS2
  49. m0qcP0dWpk1d71IAYQB0AGkAbgBnAAAAAAAAALOulzq5LGdDrMDDEBVf/w0HAAAA
  50. +Tg/TeS2m0qcP0dWpk1d70gAbwB3ACAARgBvAHUAbgBkAAAAAAAAALC71Yb1vOBB
  51. tJelg5j8IIgHAAAA+Tg/TeS2m0qcP0dWpk1d708AcABlAG4AIABEAGEAdABlAAAA
  52. AAAAAAQNOE74CB9Gs/rUSDmS8RgHAAAA+Tg/TeS2m0qcP0dWpk1d70UAcwB0ACAA
  53. QwBsAG8AcwBlAGQAIABEAGEAdABlAAAAAAAAAM1HjRZ2rblEsFECqUaiVckHAAAA
  54. +Tg/TeS2m0qcP0dWpk1d71AAcgBvAGIAYQBiAGkAbABpAHQAeQAAAAAAAACOC1Kn
  55. 57SxTYwgy1dYpUqDBwAAAPk4P03ktptKnD9HVqZNXe9FAHMAdAAgAFIAZQB2AGUA
  56. bgB1AGUAAAAAAAAAVIeGG7urrUimBcPRWNYFVAcAAAD5OD9N5LabSpw/R1amTV3v
  57. QwBsAG8AcwBlAGQAAAAAAAAA0/rRSwp+60m2+jbA0Ng7DAcAAAD5OD9N5LabSpw/
  58. R1amTV3vRABlAHMAYwByAGkAcAB0AGkAbwBuAAAAAAAAAHKT7g05dXBAlMQHPMjk
  59. GokHAAAA+Tg/TeS2m0qcP0dWpk1d70MAbwBtAG0AZQBuAHQAcwAAAAAAAAAAAAAA
  60. AAAAAAAAAAAAAAAADAAAAAQAAAAAAAAAAAAAAAAAAAAAAA==
  61. "/>
  62.                 <od:tableProperty name="HideNewField" type="1" value="0"/>
  63.                 <od:tableProperty name="GUID" type="9" value="+Tg/TeS2m0qcP0dWpk1d7w==
  64. "/>
  65.             </xsd:appinfo>
  66.         </xsd:annotation>
  67.         <xsd:complexType>
  68.             <xsd:sequence>
  69.                 <xsd:element name="ID" minOccurs="1" od:jetType="autonumber" od:sqlSType="int" od:autoUnique="yes" od:nonNullable="yes" type="xsd:int" od:rename="Id">
  70.                     <xsd:annotation>
  71.                         <xsd:appinfo>
  72.                             <od:fieldProperty name="OrdinalPosition" type="3" value="0"/>
  73.                             <od:fieldProperty name="Required" type="1" value="0"/>
  74.                             <od:fieldProperty name="AggregateType" type="4" value="-1"/>
  75.                             <od:fieldProperty name="ColumnWidth" type="3" value="720"/>
  76.                             <od:fieldProperty name="ColumnOrder" type="3" value="0"/>
  77.                             <od:fieldProperty name="ColumnHidden" type="1" value="0"/>
  78.                             <od:fieldProperty name="WSSFieldID" type="10" value="ID"/>
  79.                             <od:fieldProperty name="RowSourceType" type="10" value="Table/Query"/>
  80.                             <od:fieldProperty name="BoundColumn" type="3" value="1"/>
  81.                             <od:fieldProperty name="ColumnCount" type="3" value="1"/>
  82.                             <od:fieldProperty name="ColumnHeads" type="1" value="0"/>
  83.                             <od:fieldProperty name="AllowValueListEdits" type="1" value="0"/>
  84.                             <od:fieldProperty name="TextAlign" type="2" value="0"/>
  85.                             <od:fieldProperty name="ShowOnlyRowSourceValues" type="1" value="0"/>
  86.                             <od:fieldProperty name="GUID" type="9" value="Y90NluLtHkmKnPkgXZkaXg==
  87. "/>
  88.                         </xsd:appinfo>
  89.                     </xsd:annotation>
  90.                 </xsd:element>
  91.                 <xsd:element name="Title" minOccurs="0" od:jetType="text" od:sqlSType="nvarchar" od:rename="Titel">
  92.                     <xsd:annotation>
  93.                         <xsd:appinfo>
  94.                             <od:fieldProperty name="ColumnWidth" type="3" value="1695"/>
  95.                             <od:fieldProperty name="ColumnOrder" type="3" value="0"/>
  96.                             <od:fieldProperty name="ColumnHidden" type="1" value="0"/>
  97.                             <od:fieldProperty name="Required" type="1" value="0"/>
  98.                             <od:fieldProperty name="AllowZeroLength" type="1" value="0"/>
  99.                             <od:fieldProperty name="DisplayControl" type="3" value="109"/>
  100.                             <od:fieldProperty name="RowSourceType" type="10" value="Table/Query"/>
  101.                             <od:fieldProperty name="BoundColumn" type="3" value="1"/>
  102.                             <od:fieldProperty name="ColumnCount" type="3" value="1"/>
  103.                             <od:fieldProperty name="ColumnHeads" type="1" value="0"/>
  104.                             <od:fieldProperty name="IMEMode" type="2" value="0"/>
  105.                             <od:fieldProperty name="IMESentenceMode" type="2" value="0"/>
  106.                             <od:fieldProperty name="UnicodeCompression" type="1" value="1"/>
  107.                             <od:fieldProperty name="AllowMultipleValues" type="1" value="0"/>
  108.                             <od:fieldProperty name="AllowValueListEdits" type="1" value="0"/>
  109.                             <od:fieldProperty name="AggregateType" type="4" value="-1"/>
  110.                             <od:fieldProperty name="WSSFieldID" type="10" value="Title"/>
  111.                             <od:fieldProperty name="TextAlign" type="2" value="0"/>
  112.                             <od:fieldProperty name="ShowOnlyRowSourceValues" type="1" value="0"/>
  113.                             <od:fieldProperty name="GUID" type="9" value="i7mSDJSNc0ugCG0pjvDKlA==
  114. "/>
  115.                         </xsd:appinfo>
  116.                     </xsd:annotation>
  117.                     <xsd:simpleType>
  118.                         <xsd:restriction base="xsd:string">
  119.                             <xsd:maxLength value="100"/>
  120.                         </xsd:restriction>
  121.                     </xsd:simpleType>
  122.                 </xsd:element>
  123.                 <xsd:element name="Customer" minOccurs="0" od:jetType="longinteger" od:sqlSType="int" type="xsd:int" od:rename="Klant">
  124.                     <xsd:annotation>
  125.                         <xsd:appinfo>
  126.                             <od:fieldProperty name="Required" type="1" value="0"/>
  127.                             <od:fieldProperty name="OrdinalPosition" type="3" value="1"/>
  128.                             <od:fieldProperty name="DecimalPlaces" type="2" value="255"/>
  129.                             <od:fieldProperty name="DisplayControl" type="3" value="111"/>
  130.                             <od:fieldProperty name="RowSourceType" type="10" value="Table/Query"/>
  131.                             <od:fieldProperty name="RowSource" type="12" value="SELECT [Customers Extended].ID, [Customers Extended].[Contact Name], [Customers Extended].Company FROM [Customers Extended] ORDER BY [Customers Extended].[Contact Name];"/>
  132.                             <od:fieldProperty name="BoundColumn" type="3" value="1"/>
  133.                             <od:fieldProperty name="ColumnCount" type="3" value="3"/>
  134.                             <od:fieldProperty name="ColumnHeads" type="1" value="0"/>
  135.                             <od:fieldProperty name="ColumnWidths" type="10" value="0;2160;2160"/>
  136.                             <od:fieldProperty name="ListRows" type="3" value="16"/>
  137.                             <od:fieldProperty name="ListWidth" type="10" value="1440twip"/>
  138.                             <od:fieldProperty name="LimitToList" type="1" value="1"/>
  139.                             <od:fieldProperty name="AllowMultipleValues" type="1" value="0"/>
  140.                             <od:fieldProperty name="AllowValueListEdits" type="1" value="1"/>
  141.                             <od:fieldProperty name="AggregateType" type="4" value="-1"/>
  142.                             <od:fieldProperty name="ColumnWidth" type="3" value="2565"/>
  143.                             <od:fieldProperty name="ColumnOrder" type="3" value="0"/>
  144.                             <od:fieldProperty name="ColumnHidden" type="1" value="0"/>
  145.                             <od:fieldProperty name="ListItemsEditForm" type="12" value="Customer Details"/>
  146.                             <od:fieldProperty name="TextAlign" type="2" value="0"/>
  147.                             <od:fieldProperty name="ShowOnlyRowSourceValues" type="1" value="0"/>
  148.                             <od:fieldProperty name="DefaultValue" type="12" value="Null"/>
  149.                             <od:fieldProperty name="GUID" type="9" value="4hErgye8NkS7Iv12h+gUww==
  150. "/>
  151.                         </xsd:appinfo>
  152.                     </xsd:annotation>
  153.                 </xsd:element>
  154.                 <xsd:element name="Employee" minOccurs="0" od:jetType="longinteger" od:sqlSType="int" type="xsd:int" od:rename="Werknemer">
  155.                     <xsd:annotation>
  156.                         <xsd:appinfo>
  157.                             <od:fieldProperty name="Required" type="1" value="0"/>
  158.                             <od:fieldProperty name="OrdinalPosition" type="3" value="2"/>
  159.                             <od:fieldProperty name="DecimalPlaces" type="2" value="255"/>
  160.                             <od:fieldProperty name="DisplayControl" type="3" value="111"/>
  161.                             <od:fieldProperty name="RowSourceType" type="10" value="Table/Query"/>
  162.                             <od:fieldProperty name="RowSource" type="12" value="SELECT [Employees Extended].ID, [Employees Extended].[Employee Name] FROM [Employees Extended] ORDER BY [Employees Extended].[Employee Name];"/>
  163.                             <od:fieldProperty name="BoundColumn" type="3" value="1"/>
  164.                             <od:fieldProperty name="ColumnCount" type="3" value="2"/>
  165.                             <od:fieldProperty name="ColumnHeads" type="1" value="0"/>
  166.                             <od:fieldProperty name="ColumnWidths" type="10" value="0;1440"/>
  167.                             <od:fieldProperty name="ListRows" type="3" value="16"/>
  168.                             <od:fieldProperty name="ListWidth" type="10" value="1440twip"/>
  169.                             <od:fieldProperty name="LimitToList" type="1" value="1"/>
  170.                             <od:fieldProperty name="AllowMultipleValues" type="1" value="0"/>
  171.                             <od:fieldProperty name="AllowValueListEdits" type="1" value="1"/>
  172.                             <od:fieldProperty name="AggregateType" type="4" value="-1"/>
  173.                             <od:fieldProperty name="ColumnWidth" type="3" value="2460"/>
  174.                             <od:fieldProperty name="ColumnOrder" type="3" value="0"/>
  175.                             <od:fieldProperty name="ColumnHidden" type="1" value="0"/>
  176.                             <od:fieldProperty name="ListItemsEditForm" type="12" value="Employee Details"/>
  177.                             <od:fieldProperty name="TextAlign" type="2" value="0"/>
  178.                             <od:fieldProperty name="ShowOnlyRowSourceValues" type="1" value="0"/>
  179.                             <od:fieldProperty name="DefaultValue" type="12" value="Null"/>
  180.                             <od:fieldProperty name="GUID" type="9" value="XAMbTmCZfEakYvFBLu+CEw==
  181. "/>
  182.                         </xsd:appinfo>
  183.                     </xsd:annotation>
  184.                 </xsd:element>
  185.                 <xsd:element name="Category" minOccurs="0" od:jetType="text" od:sqlSType="nvarchar" od:rename="Categorie">
  186.                     <xsd:annotation>
  187.                         <xsd:appinfo>
  188.                             <od:fieldProperty name="Required" type="1" value="0"/>
  189.                             <od:fieldProperty name="OrdinalPosition" type="3" value="4"/>
  190.                             <od:fieldProperty name="AllowZeroLength" type="1" value="0"/>
  191.                             <od:fieldProperty name="DisplayControl" type="3" value="111"/>
  192.                             <od:fieldProperty name="RowSourceType" type="10" value="Value List"/>
  193.                             <od:fieldProperty name="RowSource" type="12" value=""(1) Categorie";"(2) Categorie";"(3) Categorie""/>
  194.                             <od:fieldProperty name="BoundColumn" type="3" value="1"/>
  195.                             <od:fieldProperty name="ColumnCount" type="3" value="1"/>
  196.                             <od:fieldProperty name="ColumnHeads" type="1" value="0"/>
  197.                             <od:fieldProperty name="ColumnWidths" type="10" value="1440"/>
  198.                             <od:fieldProperty name="ListRows" type="3" value="16"/>
  199.                             <od:fieldProperty name="ListWidth" type="10" value="1440twip"/>
  200.                             <od:fieldProperty name="LimitToList" type="1" value="1"/>
  201.                             <od:fieldProperty name="IMEMode" type="2" value="0"/>
  202.                             <od:fieldProperty name="IMESentenceMode" type="2" value="0"/>
  203.                             <od:fieldProperty name="UnicodeCompression" type="1" value="1"/>
  204.                             <od:fieldProperty name="AllowMultipleValues" type="1" value="0"/>
  205.                             <od:fieldProperty name="AllowValueListEdits" type="1" value="1"/>
  206.                             <od:fieldProperty name="AggregateType" type="4" value="-1"/>
  207.                             <od:fieldProperty name="ColumnWidth" type="3" value="-1"/>
  208.                             <od:fieldProperty name="ColumnOrder" type="3" value="0"/>
  209.                             <od:fieldProperty name="ColumnHidden" type="1" value="0"/>
  210.                             <od:fieldProperty name="TextAlign" type="2" value="0"/>
  211.                             <od:fieldProperty name="ShowOnlyRowSourceValues" type="1" value="0"/>
  212.                             <od:fieldProperty name="GUID" type="9" value="qU1Q2JSvVEO+Mf/sGyWueA==
  213. "/>
  214.                         </xsd:appinfo>
  215.                     </xsd:annotation>
  216.                     <xsd:simpleType>
  217.                         <xsd:restriction base="xsd:string">
  218.                             <xsd:maxLength value="50"/>
  219.                         </xsd:restriction>
  220.                     </xsd:simpleType>
  221.                 </xsd:element>
  222.                 <xsd:element name="Rating" minOccurs="0" od:jetType="text" od:sqlSType="nvarchar" od:rename="Waardering">
  223.                     <xsd:annotation>
  224.                         <xsd:appinfo>
  225.                             <od:fieldProperty name="ColumnWidth" type="3" value="-1"/>
  226.                             <od:fieldProperty name="ColumnOrder" type="3" value="0"/>
  227.                             <od:fieldProperty name="ColumnHidden" type="1" value="0"/>
  228.                             <od:fieldProperty name="DefaultValue" type="12" value=""Warm""/>
  229.                             <od:fieldProperty name="Required" type="1" value="0"/>
  230.                             <od:fieldProperty name="AllowZeroLength" type="1" value="0"/>
  231.                             <od:fieldProperty name="DisplayControl" type="3" value="111"/>
  232.                             <od:fieldProperty name="RowSourceType" type="10" value="Value List"/>
  233.                             <od:fieldProperty name="RowSource" type="12" value=""Heet";"Warm";"Koud""/>
  234.                             <od:fieldProperty name="BoundColumn" type="3" value="1"/>
  235.                             <od:fieldProperty name="ColumnCount" type="3" value="1"/>
  236.                             <od:fieldProperty name="ColumnHeads" type="1" value="0"/>
  237.                             <od:fieldProperty name="ColumnWidths" type="10" value="1440"/>
  238.                             <od:fieldProperty name="ListRows" type="3" value="16"/>
  239.                             <od:fieldProperty name="ListWidth" type="10" value="1440twip"/>
  240.                             <od:fieldProperty name="LimitToList" type="1" value="1"/>
  241.                             <od:fieldProperty name="IMEMode" type="2" value="0"/>
  242.                             <od:fieldProperty name="IMESentenceMode" type="2" value="0"/>
  243.                             <od:fieldProperty name="UnicodeCompression" type="1" value="1"/>
  244.                             <od:fieldProperty name="AllowMultipleValues" type="1" value="0"/>
  245.                             <od:fieldProperty name="AllowValueListEdits" type="1" value="1"/>
  246.                             <od:fieldProperty name="AggregateType" type="4" value="-1"/>
  247.                             <od:fieldProperty name="TextAlign" type="2" value="0"/>
  248.                             <od:fieldProperty name="ShowOnlyRowSourceValues" type="1" value="0"/>
  249.                             <od:fieldProperty name="GUID" type="9" value="5HCdvbt7H0mMsoaUIBbz/g==
  250. "/>
  251.                         </xsd:appinfo>
  252.                     </xsd:annotation>
  253.                     <xsd:simpleType>
  254.                         <xsd:restriction base="xsd:string">
  255.                             <xsd:maxLength value="20"/>
  256.                         </xsd:restriction>
  257.                     </xsd:simpleType>
  258.                 </xsd:element>
  259.                 <xsd:element name="How_x0020_Found" minOccurs="0" od:jetType="text" od:sqlSType="nvarchar" od:rename="Bron">
  260.                     <xsd:annotation>
  261.                         <xsd:appinfo>
  262.                             <od:fieldProperty name="Required" type="1" value="0"/>
  263.                             <od:fieldProperty name="OrdinalPosition" type="3" value="5"/>
  264.                             <od:fieldProperty name="AllowZeroLength" type="1" value="0"/>
  265.                             <od:fieldProperty name="DisplayControl" type="3" value="111"/>
  266.                             <od:fieldProperty name="RowSourceType" type="10" value="Value List"/>
  267.                             <od:fieldProperty name="RowSource" type="12" value=""Klant Doorverwezen";"Advertentie";"Telefoonboek";"Conventie";"Ongevraagd contact";"Internet";"Voormalige klant""/>
  268.                             <od:fieldProperty name="BoundColumn" type="3" value="1"/>
  269.                             <od:fieldProperty name="ColumnCount" type="3" value="1"/>
  270.                             <od:fieldProperty name="ColumnHeads" type="1" value="0"/>
  271.                             <od:fieldProperty name="ColumnWidths" type="10" value="1440"/>
  272.                             <od:fieldProperty name="ListRows" type="3" value="16"/>
  273.                             <od:fieldProperty name="ListWidth" type="10" value="1440twip"/>
  274.                             <od:fieldProperty name="LimitToList" type="1" value="1"/>
  275.                             <od:fieldProperty name="IMEMode" type="2" value="0"/>
  276.                             <od:fieldProperty name="IMESentenceMode" type="2" value="0"/>
  277.                             <od:fieldProperty name="UnicodeCompression" type="1" value="1"/>
  278.                             <od:fieldProperty name="AllowMultipleValues" type="1" value="0"/>
  279.                             <od:fieldProperty name="AllowValueListEdits" type="1" value="1"/>
  280.                             <od:fieldProperty name="AggregateType" type="4" value="-1"/>
  281.                             <od:fieldProperty name="ColumnWidth" type="3" value="-1"/>
  282.                             <od:fieldProperty name="ColumnOrder" type="3" value="0"/>
  283.                             <od:fieldProperty name="ColumnHidden" type="1" value="0"/>
  284.                             <od:fieldProperty name="TextAlign" type="2" value="0"/>
  285.                             <od:fieldProperty name="ShowOnlyRowSourceValues" type="1" value="0"/>
  286.                             <od:fieldProperty name="GUID" type="9" value="s66XOrksZ0OswMMQFV//DQ==
  287. "/>
  288.                         </xsd:appinfo>
  289.                     </xsd:annotation>
  290.                     <xsd:simpleType>
  291.                         <xsd:restriction base="xsd:string">
  292.                             <xsd:maxLength value="50"/>
  293.                         </xsd:restriction>
  294.                     </xsd:simpleType>
  295.                 </xsd:element>
  296.                 <xsd:element name="Open_x0020_Date" minOccurs="0" od:jetType="datetime" od:sqlSType="datetime" type="xsd:dateTime" od:rename="Datum geopend">
  297.                     <xsd:annotation>
  298.                         <xsd:appinfo>
  299.                             <od:fieldProperty name="Required" type="1" value="0"/>
  300.                             <od:fieldProperty name="OrdinalPosition" type="3" value="6"/>
  301.                             <od:fieldProperty name="IMEMode" type="2" value="2"/>
  302.                             <od:fieldProperty name="IMESentenceMode" type="2" value="3"/>
  303.                             <od:fieldProperty name="AggregateType" type="4" value="-1"/>
  304.                             <od:fieldProperty name="ColumnWidth" type="3" value="-1"/>
  305.                             <od:fieldProperty name="ColumnOrder" type="3" value="0"/>
  306.                             <od:fieldProperty name="ColumnHidden" type="1" value="0"/>
  307.                             <od:fieldProperty name="ValidationRule" type="12" value=">=#1/1/1900#"/>
  308.                             <od:fieldProperty name="ValidationText" type="10" value="De waarde moet groter zijn dan 1/1/1900."/>
  309.                             <od:fieldProperty name="ShowDatePicker" type="3" value="1"/>
  310.                             <od:fieldProperty name="DefaultValue" type="12" value="=Date()"/>
  311.                             <od:fieldProperty name="RowSourceType" type="10" value="Table/Query"/>
  312.                             <od:fieldProperty name="BoundColumn" type="3" value="1"/>
  313.                             <od:fieldProperty name="ColumnCount" type="3" value="1"/>
  314.                             <od:fieldProperty name="ColumnHeads" type="1" value="0"/>
  315.                             <od:fieldProperty name="AllowValueListEdits" type="1" value="0"/>
  316.                             <od:fieldProperty name="TextAlign" type="2" value="0"/>
  317.                             <od:fieldProperty name="ShowOnlyRowSourceValues" type="1" value="0"/>
  318.                             <od:fieldProperty name="GUID" type="9" value="sLvVhvW84EG0l6WDmPwgiA==
  319. "/>
  320.                         </xsd:appinfo>
  321.                     </xsd:annotation>
  322.                 </xsd:element>
  323.                 <xsd:element name="Est_x0020_Closed_x0020_Date" minOccurs="0" od:jetType="datetime" od:sqlSType="datetime" type="xsd:dateTime" od:rename="Geschatte einddatum">
  324.                     <xsd:annotation>
  325.                         <xsd:appinfo>
  326.                             <od:fieldProperty name="Required" type="1" value="0"/>
  327.                             <od:fieldProperty name="OrdinalPosition" type="3" value="7"/>
  328.                             <od:fieldProperty name="IMEMode" type="2" value="2"/>
  329.                             <od:fieldProperty name="IMESentenceMode" type="2" value="3"/>
  330.                             <od:fieldProperty name="AggregateType" type="4" value="-1"/>
  331.                             <od:fieldProperty name="ColumnWidth" type="3" value="1920"/>
  332.                             <od:fieldProperty name="ColumnOrder" type="3" value="0"/>
  333.                             <od:fieldProperty name="ColumnHidden" type="1" value="0"/>
  334.                             <od:fieldProperty name="ValidationRule" type="12" value=">=#1/1/1900#"/>
  335.                             <od:fieldProperty name="ValidationText" type="10" value="De waarde moet groter zijn dan 1/1/1900."/>
  336.                             <od:fieldProperty name="ShowDatePicker" type="3" value="1"/>
  337.                             <od:fieldProperty name="RowSourceType" type="10" value="Table/Query"/>
  338.                             <od:fieldProperty name="BoundColumn" type="3" value="1"/>
  339.                             <od:fieldProperty name="ColumnCount" type="3" value="1"/>
  340.                             <od:fieldProperty name="ColumnHeads" type="1" value="0"/>
  341.                             <od:fieldProperty name="AllowValueListEdits" type="1" value="0"/>
  342.                             <od:fieldProperty name="TextAlign" type="2" value="0"/>
  343.                             <od:fieldProperty name="ShowOnlyRowSourceValues" type="1" value="0"/>
  344.                             <od:fieldProperty name="GUID" type="9" value="BA04TvgIH0az+tRIOZLxGA==
  345. "/>
  346.                         </xsd:appinfo>
  347.                     </xsd:annotation>
  348.                 </xsd:element>
  349.                 <xsd:element name="Probability" minOccurs="0" od:jetType="double" od:sqlSType="float" type="xsd:double" od:rename="Kans">
  350.                     <xsd:annotation>
  351.                         <xsd:appinfo>
  352.                             <od:fieldProperty name="Required" type="1" value="0"/>
  353.                             <od:fieldProperty name="OrdinalPosition" type="3" value="8"/>
  354.                             <od:fieldProperty name="DefaultValue" type="12" value="0.8"/>
  355.                             <od:fieldProperty name="Format" type="10" value="Percent"/>
  356.                             <od:fieldProperty name="DecimalPlaces" type="2" value="0"/>
  357.                             <od:fieldProperty name="DisplayControl" type="3" value="109"/>
  358.                             <od:fieldProperty name="AggregateType" type="4" value="-1"/>
  359.                             <od:fieldProperty name="ColumnWidth" type="3" value="-1"/>
  360.                             <od:fieldProperty name="ColumnOrder" type="3" value="0"/>
  361.                             <od:fieldProperty name="ColumnHidden" type="1" value="0"/>
  362.                             <od:fieldProperty name="RowSourceType" type="10" value="Table/Query"/>
  363.                             <od:fieldProperty name="BoundColumn" type="3" value="1"/>
  364.                             <od:fieldProperty name="ColumnCount" type="3" value="1"/>
  365.                             <od:fieldProperty name="ColumnHeads" type="1" value="0"/>
  366.                             <od:fieldProperty name="AllowMultipleValues" type="1" value="0"/>
  367.                             <od:fieldProperty name="AllowValueListEdits" type="1" value="0"/>
  368.                             <od:fieldProperty name="TextAlign" type="2" value="0"/>
  369.                             <od:fieldProperty name="ValidationRule" type="12" value=">=0 And <=1"/>
  370.                             <od:fieldProperty name="ValidationText" type="10" value="De waarde moet tussen 0 en 1 liggen"/>
  371.                             <od:fieldProperty name="ShowOnlyRowSourceValues" type="1" value="0"/>
  372.                             <od:fieldProperty name="GUID" type="9" value="zUeNFnatuUSwUQKpRqJVyQ==
  373. "/>
  374.                         </xsd:appinfo>
  375.                     </xsd:annotation>
  376.                 </xsd:element>
  377.                 <xsd:element name="Est_x0020_Revenue" minOccurs="0" od:jetType="currency" od:sqlSType="money" type="xsd:double" od:rename="Geschatte opbrengst">
  378.                     <xsd:annotation>
  379.                         <xsd:appinfo>
  380.                             <od:fieldProperty name="ColumnWidth" type="3" value="1620"/>
  381.                             <od:fieldProperty name="ColumnOrder" type="3" value="0"/>
  382.                             <od:fieldProperty name="ColumnHidden" type="1" value="0"/>
  383.                             <od:fieldProperty name="Format" type="10" value="Currency"/>
  384.                             <od:fieldProperty name="DecimalPlaces" type="2" value="255"/>
  385.                             <od:fieldProperty name="Required" type="1" value="0"/>
  386.                             <od:fieldProperty name="AggregateType" type="4" value="-1"/>
  387.                             <od:fieldProperty name="RowSourceType" type="10" value="Table/Query"/>
  388.                             <od:fieldProperty name="BoundColumn" type="3" value="1"/>
  389.                             <od:fieldProperty name="ColumnCount" type="3" value="1"/>
  390.                             <od:fieldProperty name="ColumnHeads" type="1" value="0"/>
  391.                             <od:fieldProperty name="AllowValueListEdits" type="1" value="0"/>
  392.                             <od:fieldProperty name="TextAlign" type="2" value="0"/>
  393.                             <od:fieldProperty name="ShowOnlyRowSourceValues" type="1" value="0"/>
  394.                             <od:fieldProperty name="GUID" type="9" value="jgtSp+e0sU2MIMtXWKVKgw==
  395. "/>
  396.                         </xsd:appinfo>
  397.                     </xsd:annotation>
  398.                 </xsd:element>
  399.                 <xsd:element name="Closed" minOccurs="1" od:jetType="yesno" od:sqlSType="bit" od:nonNullable="yes" type="xsd:boolean" od:rename="Gesloten">
  400.                     <xsd:annotation>
  401.                         <xsd:appinfo>
  402.                             <od:fieldProperty name="Required" type="1" value="0"/>
  403.                             <od:fieldProperty name="OrdinalPosition" type="3" value="10"/>
  404.                             <od:fieldProperty name="Format" type="10" value="Yes/No"/>
  405.                             <od:fieldProperty name="DisplayControl" type="3" value="106"/>
  406.                             <od:fieldProperty name="AggregateType" type="4" value="-1"/>
  407.                             <od:fieldProperty name="ColumnWidth" type="3" value="-1"/>
  408.                             <od:fieldProperty name="ColumnOrder" type="3" value="0"/>
  409.                             <od:fieldProperty name="ColumnHidden" type="1" value="0"/>
  410.                             <od:fieldProperty name="DefaultValue" type="12" value="False"/>
  411.                             <od:fieldProperty name="RowSourceType" type="10" value="Table/Query"/>
  412.                             <od:fieldProperty name="BoundColumn" type="3" value="1"/>
  413.                             <od:fieldProperty name="ColumnCount" type="3" value="1"/>
  414.                             <od:fieldProperty name="ColumnHeads" type="1" value="0"/>
  415.                             <od:fieldProperty name="AllowValueListEdits" type="1" value="0"/>
  416.                             <od:fieldProperty name="TextAlign" type="2" value="0"/>
  417.                             <od:fieldProperty name="ShowOnlyRowSourceValues" type="1" value="0"/>
  418.                             <od:fieldProperty name="GUID" type="9" value="VIeGG7urrUimBcPRWNYFVA==
  419. "/>
  420.                         </xsd:appinfo>
  421.                     </xsd:annotation>
  422.                 </xsd:element>
  423.                 <xsd:element name="Description" minOccurs="0" od:jetType="memo" od:sqlSType="ntext" od:textFormat="1" od:rename="Beschrijving">
  424.                     <xsd:annotation>
  425.                         <xsd:appinfo>
  426.                             <od:fieldProperty name="TextFormat" type="2" value="1"/>
  427.                             <od:fieldProperty name="Required" type="1" value="0"/>
  428.                             <od:fieldProperty name="OrdinalPosition" type="3" value="11"/>
  429.                             <od:fieldProperty name="AllowZeroLength" type="1" value="0"/>
  430.                             <od:fieldProperty name="IMEMode" type="2" value="0"/>
  431.                             <od:fieldProperty name="IMESentenceMode" type="2" value="0"/>
  432.                             <od:fieldProperty name="UnicodeCompression" type="1" value="1"/>
  433.                             <od:fieldProperty name="AppendOnly" type="1" value="0"/>
  434.                             <od:fieldProperty name="AggregateType" type="4" value="-1"/>
  435.                             <od:fieldProperty name="ColumnWidth" type="3" value="-1"/>
  436.                             <od:fieldProperty name="ColumnOrder" type="3" value="0"/>
  437.                             <od:fieldProperty name="ColumnHidden" type="1" value="0"/>
  438.                             <od:fieldProperty name="RowSourceType" type="10" value="Table/Query"/>
  439.                             <od:fieldProperty name="BoundColumn" type="3" value="1"/>
  440.                             <od:fieldProperty name="ColumnCount" type="3" value="1"/>
  441.                             <od:fieldProperty name="ColumnHeads" type="1" value="0"/>
  442.                             <od:fieldProperty name="AllowValueListEdits" type="1" value="0"/>
  443.                             <od:fieldProperty name="TextAlign" type="2" value="0"/>
  444.                             <od:fieldProperty name="ShowOnlyRowSourceValues" type="1" value="0"/>
  445.                             <od:fieldProperty name="GUID" type="9" value="0/rRSwp+60m2+jbA0Ng7DA==
  446. "/>
  447.                         </xsd:appinfo>
  448.                     </xsd:annotation>
  449.                     <xsd:simpleType>
  450.                         <xsd:restriction base="xsd:string">
  451.                             <xsd:maxLength value="536870910"/>
  452.                         </xsd:restriction>
  453.                     </xsd:simpleType>
  454.                 </xsd:element>
  455.                 <xsd:element name="Comments" minOccurs="0" od:jetType="memo" od:sqlSType="ntext" od:appendOnly="yes" od:rename="Opmerkingen">
  456.                     <xsd:annotation>
  457.                         <xsd:appinfo>
  458.                             <od:fieldProperty name="AppendOnly" type="1" value="1"/>
  459.                             <od:fieldProperty name="ColumnWidth" type="3" value="-1"/>
  460.                             <od:fieldProperty name="ColumnOrder" type="3" value="0"/>
  461.                             <od:fieldProperty name="ColumnHidden" type="1" value="0"/>
  462.                             <od:fieldProperty name="Required" type="1" value="0"/>
  463.                             <od:fieldProperty name="AllowZeroLength" type="1" value="0"/>
  464.                             <od:fieldProperty name="IMEMode" type="2" value="0"/>
  465.                             <od:fieldProperty name="IMESentenceMode" type="2" value="0"/>
  466.                             <od:fieldProperty name="UnicodeCompression" type="1" value="1"/>
  467.                             <od:fieldProperty name="TextFormat" type="2" value="0"/>
  468.                             <od:fieldProperty name="AggregateType" type="4" value="-1"/>
  469.                             <od:fieldProperty name="RowSourceType" type="10" value="Table/Query"/>
  470.                             <od:fieldProperty name="BoundColumn" type="3" value="1"/>
  471.                             <od:fieldProperty name="ColumnCount" type="3" value="1"/>
  472.                             <od:fieldProperty name="ColumnHeads" type="1" value="0"/>
  473.                             <od:fieldProperty name="AllowValueListEdits" type="1" value="0"/>
  474.                             <od:fieldProperty name="TextAlign" type="2" value="0"/>
  475.                             <od:fieldProperty name="ShowOnlyRowSourceValues" type="1" value="0"/>
  476.                             <od:fieldProperty name="GUID" type="9" value="cpPuDTl1cECUxAc8yOQaiQ==
  477. "/>
  478.                         </xsd:appinfo>
  479.                     </xsd:annotation>
  480.                     <xsd:simpleType>
  481.                         <xsd:restriction base="xsd:string">
  482.                             <xsd:maxLength value="536870910"/>
  483.                         </xsd:restriction>
  484.                     </xsd:simpleType>
  485.                 </xsd:element>
  486.             </xsd:sequence>
  487.         </xsd:complexType>
  488.     </xsd:element>
  489. </xsd:schema>
  490.